package com.first.agent.dao;

import com.first.agent.pojo.AgentCustomer;
import com.first.agent.pojo.Contacts;
import com.first.agent.pojo.Keyword;

import java.sql.SQLException;
import java.util.List;

/**
 * Created with IntelliJ IDEA.
 * User: lxm
 * Date: 2022/11/15 10:10
 * Description:
 * Version: V1.0
 */
public interface CustomerDao {
    //查询
    List customerQuery(int page,int limit,String customerName) throws SQLException;
    int countCustomer(String customerName) throws SQLException;
    //新增
    int addCustomer(AgentCustomer customer, Contacts contacts) throws SQLException;
    int delCustomer(Integer cus_id) throws SQLException;
    int openCustomer(Integer cus_id) throws SQLException;
    int updateCustomer(AgentCustomer customer, Contacts contacts) throws SQLException;
    int addKeyWords(Keyword keyword) throws SQLException;
    int keyWordCustomer(String customerName) throws SQLException;

}
